using System.Linq;
using System.Text;
using System.Diagnostics;
using System.Runtime.Serialization;
using System.Collections;
using System.Data;
using System.ComponentModel;
using System.Data.OracleClient;
using WPFExcelReport.Helpers;
using WPFExcelReport.Controls;
namespace WPFExcelReport
{
   public partial class VVHANSTA
    {
      #region======ColumnSchema==========
       /*
                public string VHASA { get { if (dwMaster == null) return ""; return dwMaster["VHASA"].ToString(); } set { if (dwMaster == null) return; dwMaster["VHASA"] = value; OnPropertyChanged("VHASA", value); } } //lENGth 2
                public string VHAMANDANT { get { if (dwMaster == null) return ""; return dwMaster["VHAMANDANT"].ToString(); } set { if (dwMaster == null) return; dwMaster["VHAMANDANT"] = value; OnPropertyChanged("VHAMANDANT", value); } } //lENGth 2
                public string VHAJHJJ { get { if (dwMaster == null) return ""; return dwMaster["VHAJHJJ"].ToString(); } set { if (dwMaster == null) return; dwMaster["VHAJHJJ"] = value; OnPropertyChanged("VHAJHJJ", value); } } //lENGth 4
                public string VHAMM { get { if (dwMaster == null) return ""; return dwMaster["VHAMM"].ToString(); } set { if (dwMaster == null) return; dwMaster["VHAMM"] = value; OnPropertyChanged("VHAMM", value); } } //lENGth 2
                public string VHALFDNR { get { if (dwMaster == null) return ""; return dwMaster["VHALFDNR"].ToString(); } set { if (dwMaster == null) return; dwMaster["VHALFDNR"] = value; OnPropertyChanged("VHALFDNR", value); } } //lENGth 6
                public string VHAAENB { get { if (dwMaster == null) return ""; return dwMaster["VHAAENB"].ToString(); } set { if (dwMaster == null) return; dwMaster["VHAAENB"] = value; OnPropertyChanged("VHAAENB", value); } } //lENGth 8
                public double VHAAEND { get { if (dwMaster == null) return 0.0; return  Convert.ToDouble(dwMaster["VHAAEND"].ToString()); } set { if (dwMaster == null) return; dwMaster["VHAAEND"] = value; OnPropertyChanged("VHAAEND", value); } } //lENGth 0
                public string VHANEUB { get { if (dwMaster == null) return ""; return dwMaster["VHANEUB"].ToString(); } set { if (dwMaster == null) return; dwMaster["VHANEUB"] = value; OnPropertyChanged("VHANEUB", value); } } //lENGth 8
                public double VHANEUD { get { if (dwMaster == null) return 0.0; return  Convert.ToDouble(dwMaster["VHANEUD"].ToString()); } set { if (dwMaster == null) return; dwMaster["VHANEUD"] = value; OnPropertyChanged("VHANEUD", value); } } //lENGth 0
                public string VHAVB { get { if (dwMaster == null) return ""; return dwMaster["VHAVB"].ToString(); } set { if (dwMaster == null) return; dwMaster["VHAVB"] = value; OnPropertyChanged("VHAVB", value); } } //lENGth 3
                public string VHABUCHKRS { get { if (dwMaster == null) return ""; return dwMaster["VHABUCHKRS"].ToString(); } set { if (dwMaster == null) return; dwMaster["VHABUCHKRS"] = value; OnPropertyChanged("VHABUCHKRS", value); } } //lENGth 3
                public string VHAKUNDNR { get { if (dwMaster == null) return ""; return dwMaster["VHAKUNDNR"].ToString(); } set { if (dwMaster == null) return; dwMaster["VHAKUNDNR"] = value; OnPropertyChanged("VHAKUNDNR", value); } } //lENGth 8
                public string VHALIEFNR { get { if (dwMaster == null) return ""; return dwMaster["VHALIEFNR"].ToString(); } set { if (dwMaster == null) return; dwMaster["VHALIEFNR"] = value; OnPropertyChanged("VHALIEFNR", value); } } //lENGth 8
                public string VHARENR { get { if (dwMaster == null) return ""; return dwMaster["VHARENR"].ToString(); } set { if (dwMaster == null) return; dwMaster["VHARENR"] = value; OnPropertyChanged("VHARENR", value); } } //lENGth 10
                public string VHAREPOS { get { if (dwMaster == null) return ""; return dwMaster["VHAREPOS"].ToString(); } set { if (dwMaster == null) return; dwMaster["VHAREPOS"] = value; OnPropertyChanged("VHAREPOS", value); } } //lENGth 3
                public string VHABEM { get { if (dwMaster == null) return ""; return dwMaster["VHABEM"].ToString(); } set { if (dwMaster == null) return; dwMaster["VHABEM"] = value; OnPropertyChanged("VHABEM", value); } } //lENGth 250
                public string VHALO { get { if (dwMaster == null) return ""; return dwMaster["VHALO"].ToString(); } set { if (dwMaster == null) return; dwMaster["VHALO"] = value; OnPropertyChanged("VHALO", value); } } //lENGth 2
                public string VHALAND { get { if (dwMaster == null) return ""; return dwMaster["VHALAND"].ToString(); } set { if (dwMaster == null) return; dwMaster["VHALAND"] = value; OnPropertyChanged("VHALAND", value); } } //lENGth 3
                public string VHAARTGS { get { if (dwMaster == null) return ""; return dwMaster["VHAARTGS"].ToString(); } set { if (dwMaster == null) return; dwMaster["VHAARTGS"] = value; OnPropertyChanged("VHAARTGS", value); } } //lENGth 2
                public string VHAVZWEIG { get { if (dwMaster == null) return ""; return dwMaster["VHAVZWEIG"].ToString(); } set { if (dwMaster == null) return; dwMaster["VHAVZWEIG"] = value; OnPropertyChanged("VHAVZWEIG", value); } } //lENGth 1
                public string VHAURLAND { get { if (dwMaster == null) return ""; return dwMaster["VHAURLAND"].ToString(); } set { if (dwMaster == null) return; dwMaster["VHAURLAND"] = value; OnPropertyChanged("VHAURLAND", value); } } //lENGth 3
                public string VHAZOLLTNR { get { if (dwMaster == null) return ""; return dwMaster["VHAZOLLTNR"].ToString(); } set { if (dwMaster == null) return; dwMaster["VHAZOLLTNR"] = value; OnPropertyChanged("VHAZOLLTNR", value); } } //lENGth 8
                public string VHAVERF { get { if (dwMaster == null) return ""; return dwMaster["VHAVERF"].ToString(); } set { if (dwMaster == null) return; dwMaster["VHAVERF"] = value; OnPropertyChanged("VHAVERF", value); } } //lENGth 5
                public string VHAEIGM { get { if (dwMaster == null) return ""; return dwMaster["VHAEIGM"].ToString(); } set { if (dwMaster == null) return; dwMaster["VHAEIGM"] = value; OnPropertyChanged("VHAEIGM", value); } } //lENGth 13
                public string VHABMASS { get { if (dwMaster == null) return ""; return dwMaster["VHABMASS"].ToString(); } set { if (dwMaster == null) return; dwMaster["VHABMASS"] = value; OnPropertyChanged("VHABMASS", value); } } //lENGth 13
                public string VHARWERT { get { if (dwMaster == null) return ""; return dwMaster["VHARWERT"].ToString(); } set { if (dwMaster == null) return; dwMaster["VHARWERT"] = value; OnPropertyChanged("VHARWERT", value); } } //lENGth 13
                public string VHASWERT { get { if (dwMaster == null) return ""; return dwMaster["VHASWERT"].ToString(); } set { if (dwMaster == null) return; dwMaster["VHASWERT"] = value; OnPropertyChanged("VHASWERT", value); } } //lENGth 13
                public string VHABMM { get { if (dwMaster == null) return ""; return dwMaster["VHABMM"].ToString(); } set { if (dwMaster == null) return; dwMaster["VHABMM"] = value; OnPropertyChanged("VHABMM", value); } } //lENGth 2
                public string VHABJJ { get { if (dwMaster == null) return ""; return dwMaster["VHABJJ"].ToString(); } set { if (dwMaster == null) return; dwMaster["VHABJJ"] = value; OnPropertyChanged("VHABJJ", value); } } //lENGth 2
                public string VHAWAEHRKZ { get { if (dwMaster == null) return ""; return dwMaster["VHAWAEHRKZ"].ToString(); } set { if (dwMaster == null) return; dwMaster["VHAWAEHRKZ"] = value; OnPropertyChanged("VHAWAEHRKZ", value); } } //lENGth 1
                public string VHAEXRENR { get { if (dwMaster == null) return ""; return dwMaster["VHAEXRENR"].ToString(); } set { if (dwMaster == null) return; dwMaster["VHAEXRENR"] = value; OnPropertyChanged("VHAEXRENR", value); } } //lENGth 20
                public string VHAZOLLNR { get { if (dwMaster == null) return ""; return dwMaster["VHAZOLLNR"].ToString(); } set { if (dwMaster == null) return; dwMaster["VHAZOLLNR"] = value; OnPropertyChanged("VHAZOLLNR", value); } } //lENGth 7
                public string VHAFIRMNR { get { if (dwMaster == null) return ""; return dwMaster["VHAFIRMNR"].ToString(); } set { if (dwMaster == null) return; dwMaster["VHAFIRMNR"] = value; OnPropertyChanged("VHAFIRMNR", value); } } //lENGth 7
                public string VHAURREGION { get { if (dwMaster == null) return ""; return dwMaster["VHAURREGION"].ToString(); } set { if (dwMaster == null) return; dwMaster["VHAURREGION"] = value; OnPropertyChanged("VHAURREGION", value); } } //lENGth 2
                public string VHASTEUERNR { get { if (dwMaster == null) return ""; return dwMaster["VHASTEUERNR"].ToString(); } set { if (dwMaster == null) return; dwMaster["VHASTEUERNR"] = value; OnPropertyChanged("VHASTEUERNR", value); } } //lENGth 11
                public string VHAUNTERNR { get { if (dwMaster == null) return ""; return dwMaster["VHAUNTERNR"].ToString(); } set { if (dwMaster == null) return; dwMaster["VHAUNTERNR"] = value; OnPropertyChanged("VHAUNTERNR", value); } } //lENGth 3
                public string VHASITZVERS { get { if (dwMaster == null) return ""; return dwMaster["VHASITZVERS"].ToString(); } set { if (dwMaster == null) return; dwMaster["VHASITZVERS"] = value; OnPropertyChanged("VHASITZVERS", value); } } //lENGth 1
                public double VHAREDAT { get { if (dwMaster == null) return 0.0; return  Convert.ToDouble(dwMaster["VHAREDAT"].ToString()); } set { if (dwMaster == null) return; dwMaster["VHAREDAT"] = value; OnPropertyChanged("VHAREDAT", value); } } //lENGth 0
                public string VHABMME { get { if (dwMaster == null) return ""; return dwMaster["VHABMME"].ToString(); } set { if (dwMaster == null) return; dwMaster["VHABMME"] = value; OnPropertyChanged("VHABMME", value); } } //lENGth 3
                public string VHAFILLER1 { get { if (dwMaster == null) return ""; return dwMaster["VHAFILLER1"].ToString(); } set { if (dwMaster == null) return; dwMaster["VHAFILLER1"] = value; OnPropertyChanged("VHAFILLER1", value); } } //lENGth 27
                public string VHAKOBRA { get { if (dwMaster == null) return ""; return dwMaster["VHAKOBRA"].ToString(); } set { if (dwMaster == null) return; dwMaster["VHAKOBRA"] = value; OnPropertyChanged("VHAKOBRA", value); } } //lENGth 1
                public string VHAKLAND { get { if (dwMaster == null) return ""; return dwMaster["VHAKLAND"].ToString(); } set { if (dwMaster == null) return; dwMaster["VHAKLAND"] = value; OnPropertyChanged("VHAKLAND", value); } } //lENGth 3
                public string VHACONTV { get { if (dwMaster == null) return ""; return dwMaster["VHACONTV"].ToString(); } set { if (dwMaster == null) return; dwMaster["VHACONTV"] = value; OnPropertyChanged("VHACONTV", value); } } //lENGth 1
                public string VHATPMLKZ { get { if (dwMaster == null) return ""; return dwMaster["VHATPMLKZ"].ToString(); } set { if (dwMaster == null) return; dwMaster["VHATPMLKZ"] = value; OnPropertyChanged("VHATPMLKZ", value); } } //lENGth 3
                public string VHAAZOLLST { get { if (dwMaster == null) return ""; return dwMaster["VHAAZOLLST"].ToString(); } set { if (dwMaster == null) return; dwMaster["VHAAZOLLST"] = value; OnPropertyChanged("VHAAZOLLST", value); } } //lENGth 6
                public string VHAIURLAND { get { if (dwMaster == null) return ""; return dwMaster["VHAIURLAND"].ToString(); } set { if (dwMaster == null) return; dwMaster["VHAIURLAND"] = value; OnPropertyChanged("VHAIURLAND", value); } } //lENGth 2
                public string VHAIVZWEIG { get { if (dwMaster == null) return ""; return dwMaster["VHAIVZWEIG"].ToString(); } set { if (dwMaster == null) return; dwMaster["VHAIVZWEIG"] = value; OnPropertyChanged("VHAIVZWEIG", value); } } //lENGth 1
                public double VHAVERSDAT { get { if (dwMaster == null) return 0.0; return  Convert.ToDouble(dwMaster["VHAVERSDAT"].ToString()); } set { if (dwMaster == null) return; dwMaster["VHAVERSDAT"] = value; OnPropertyChanged("VHAVERSDAT", value); } } //lENGth 0
                public string VHAKUNDNRV { get { if (dwMaster == null) return ""; return dwMaster["VHAKUNDNRV"].ToString(); } set { if (dwMaster == null) return; dwMaster["VHAKUNDNRV"] = value; OnPropertyChanged("VHAKUNDNRV", value); } } //lENGth 8
                public string VHAADRSLV { get { if (dwMaster == null) return ""; return dwMaster["VHAADRSLV"].ToString(); } set { if (dwMaster == null) return; dwMaster["VHAADRSLV"] = value; OnPropertyChanged("VHAADRSLV", value); } } //lENGth 8
                public string VHAKUNDNRE { get { if (dwMaster == null) return ""; return dwMaster["VHAKUNDNRE"].ToString(); } set { if (dwMaster == null) return; dwMaster["VHAKUNDNRE"] = value; OnPropertyChanged("VHAKUNDNRE", value); } } //lENGth 8
                public string VHAADRSLE { get { if (dwMaster == null) return ""; return dwMaster["VHAADRSLE"].ToString(); } set { if (dwMaster == null) return; dwMaster["VHAADRSLE"] = value; OnPropertyChanged("VHAADRSLE", value); } } //lENGth 8
                public string VHAKCODE { get { if (dwMaster == null) return ""; return dwMaster["VHAKCODE"].ToString(); } set { if (dwMaster == null) return; dwMaster["VHAKCODE"] = value; OnPropertyChanged("VHAKCODE", value); } } //lENGth 1
                public string VHAVRCHTG { get { if (dwMaster == null) return ""; return dwMaster["VHAVRCHTG"].ToString(); } set { if (dwMaster == null) return; dwMaster["VHAVRCHTG"] = value; OnPropertyChanged("VHAVRCHTG", value); } } //lENGth 1
                public string VHABEWPFL { get { if (dwMaster == null) return ""; return dwMaster["VHABEWPFL"].ToString(); } set { if (dwMaster == null) return; dwMaster["VHABEWPFL"] = value; OnPropertyChanged("VHABEWPFL", value); } } //lENGth 1
                public string VHADRVERT { get { if (dwMaster == null) return ""; return dwMaster["VHADRVERT"].ToString(); } set { if (dwMaster == null) return; dwMaster["VHADRVERT"] = value; OnPropertyChanged("VHADRVERT", value); } } //lENGth 20
                public string VHACBOOKNO { get { if (dwMaster == null) return ""; return dwMaster["VHACBOOKNO"].ToString(); } set { if (dwMaster == null) return; dwMaster["VHACBOOKNO"] = value; OnPropertyChanged("VHACBOOKNO", value); } } //lENGth 15
                public double VHACITEMNO { get { if (dwMaster == null) return 0.0; return  Convert.ToDouble(dwMaster["VHACITEMNO"].ToString()); } set { if (dwMaster == null) return; dwMaster["VHACITEMNO"] = value; OnPropertyChanged("VHACITEMNO", value); } } //lENGth 0
                public string VHABOOKCOR { get { if (dwMaster == null) return ""; return dwMaster["VHABOOKCOR"].ToString(); } set { if (dwMaster == null) return; dwMaster["VHABOOKCOR"] = value; OnPropertyChanged("VHABOOKCOR", value); } } //lENGth 15
                public string VHAZOLLST { get { if (dwMaster == null) return ""; return dwMaster["VHAZOLLST"].ToString(); } set { if (dwMaster == null) return; dwMaster["VHAZOLLST"] = value; OnPropertyChanged("VHAZOLLST", value); } } //lENGth 6
                public string VHAZFORMNR { get { if (dwMaster == null) return ""; return dwMaster["VHAZFORMNR"].ToString(); } set { if (dwMaster == null) return; dwMaster["VHAZFORMNR"] = value; OnPropertyChanged("VHAZFORMNR", value); } } //lENGth 10
                public string VHAARTST { get { if (dwMaster == null) return ""; return dwMaster["VHAARTST"].ToString(); } set { if (dwMaster == null) return; dwMaster["VHAARTST"] = value; OnPropertyChanged("VHAARTST", value); } } //lENGth 1
                public string VHARWARTST { get { if (dwMaster == null) return ""; return dwMaster["VHARWARTST"].ToString(); } set { if (dwMaster == null) return; dwMaster["VHARWARTST"] = value; OnPropertyChanged("VHARWARTST", value); } } //lENGth 1
                public string VHALIEFSCHNR { get { if (dwMaster == null) return ""; return dwMaster["VHALIEFSCHNR"].ToString(); } set { if (dwMaster == null) return; dwMaster["VHALIEFSCHNR"] = value; OnPropertyChanged("VHALIEFSCHNR", value); } } //lENGth 10
                public string VHACHARGE { get { if (dwMaster == null) return ""; return dwMaster["VHACHARGE"].ToString(); } set { if (dwMaster == null) return; dwMaster["VHACHARGE"] = value; OnPropertyChanged("VHACHARGE", value); } } //lENGth 12
                public string VHARWART { get { if (dwMaster == null) return ""; return dwMaster["VHARWART"].ToString(); } set { if (dwMaster == null) return; dwMaster["VHARWART"] = value; OnPropertyChanged("VHARWART", value); } } //lENGth 20
                public string VHARWVAR { get { if (dwMaster == null) return ""; return dwMaster["VHARWVAR"].ToString(); } set { if (dwMaster == null) return; dwMaster["VHARWVAR"] = value; OnPropertyChanged("VHARWVAR", value); } } //lENGth 3
                public double VHAROHWERT { get { if (dwMaster == null) return 0.0; return  Convert.ToDouble(dwMaster["VHAROHWERT"].ToString()); } set { if (dwMaster == null) return; dwMaster["VHAROHWERT"] = value; OnPropertyChanged("VHAROHWERT", value); } } //lENGth 0
                public string VHAFWKUNDNR { get { if (dwMaster == null) return ""; return dwMaster["VHAFWKUNDNR"].ToString(); } set { if (dwMaster == null) return; dwMaster["VHAFWKUNDNR"] = value; OnPropertyChanged("VHAFWKUNDNR", value); } } //lENGth 8
                public string VHAFWWERK { get { if (dwMaster == null) return ""; return dwMaster["VHAFWWERK"].ToString(); } set { if (dwMaster == null) return; dwMaster["VHAFWWERK"] = value; OnPropertyChanged("VHAFWWERK", value); } } //lENGth 3
                public string VHAFWABT { get { if (dwMaster == null) return ""; return dwMaster["VHAFWABT"].ToString(); } set { if (dwMaster == null) return; dwMaster["VHAFWABT"] = value; OnPropertyChanged("VHAFWABT", value); } } //lENGth 3
                public string VHAFWART { get { if (dwMaster == null) return ""; return dwMaster["VHAFWART"].ToString(); } set { if (dwMaster == null) return; dwMaster["VHAFWART"] = value; OnPropertyChanged("VHAFWART", value); } } //lENGth 20
                public string VHAFWVAR { get { if (dwMaster == null) return ""; return dwMaster["VHAFWVAR"].ToString(); } set { if (dwMaster == null) return; dwMaster["VHAFWVAR"] = value; OnPropertyChanged("VHAFWVAR", value); } } //lENGth 3
                public double VHALFMENGE { get { if (dwMaster == null) return 0.0; return  Convert.ToDouble(dwMaster["VHALFMENGE"].ToString()); } set { if (dwMaster == null) return; dwMaster["VHALFMENGE"] = value; OnPropertyChanged("VHALFMENGE", value); } } //lENGth 0
                public string VHABUSIMODE { get { if (dwMaster == null) return ""; return dwMaster["VHABUSIMODE"].ToString(); } set { if (dwMaster == null) return; dwMaster["VHABUSIMODE"] = value; OnPropertyChanged("VHABUSIMODE", value); } } //lENGth 3
                public string VHAZUSTAND { get { if (dwMaster == null) return ""; return dwMaster["VHAZUSTAND"].ToString(); } set { if (dwMaster == null) return; dwMaster["VHAZUSTAND"] = value; OnPropertyChanged("VHAZUSTAND", value); } } //lENGth 4
                public double VHALAEAEND { get { if (dwMaster == null) return 0.0; return  Convert.ToDouble(dwMaster["VHALAEAEND"].ToString()); } set { if (dwMaster == null) return; dwMaster["VHALAEAEND"] = value; OnPropertyChanged("VHALAEAEND", value); } } //lENGth 0
                public double VHARWMENGE { get { if (dwMaster == null) return 0.0; return  Convert.ToDouble(dwMaster["VHARWMENGE"].ToString()); } set { if (dwMaster == null) return; dwMaster["VHARWMENGE"] = value; OnPropertyChanged("VHARWMENGE", value); } } //lENGth 0
                public string VHALIEFBED { get { if (dwMaster == null) return ""; return dwMaster["VHALIEFBED"].ToString(); } set { if (dwMaster == null) return; dwMaster["VHALIEFBED"] = value; OnPropertyChanged("VHALIEFBED", value); } } //lENGth 3
                public double VHABRTGEW { get { if (dwMaster == null) return 0.0; return  Convert.ToDouble(dwMaster["VHABRTGEW"].ToString()); } set { if (dwMaster == null) return; dwMaster["VHABRTGEW"] = value; OnPropertyChanged("VHABRTGEW", value); } } //lENGth 0
                public double VHANETGEW { get { if (dwMaster == null) return 0.0; return  Convert.ToDouble(dwMaster["VHANETGEW"].ToString()); } set { if (dwMaster == null) return; dwMaster["VHANETGEW"] = value; OnPropertyChanged("VHANETGEW", value); } } //lENGth 0
                public string VHAWAEHRSL { get { if (dwMaster == null) return ""; return dwMaster["VHAWAEHRSL"].ToString(); } set { if (dwMaster == null) return; dwMaster["VHAWAEHRSL"] = value; OnPropertyChanged("VHAWAEHRSL", value); } } //lENGth 3
                public double VHAKURS { get { if (dwMaster == null) return 0.0; return  Convert.ToDouble(dwMaster["VHAKURS"].ToString()); } set { if (dwMaster == null) return; dwMaster["VHAKURS"] = value; OnPropertyChanged("VHAKURS", value); } } //lENGth 0
                public double VHABETRAG { get { if (dwMaster == null) return 0.0; return  Convert.ToDouble(dwMaster["VHABETRAG"].ToString()); } set { if (dwMaster == null) return; dwMaster["VHABETRAG"] = value; OnPropertyChanged("VHABETRAG", value); } } //lENGth 0
                public double VHALIEFSCH { get { if (dwMaster == null) return 0.0; return  Convert.ToDouble(dwMaster["VHALIEFSCH"].ToString()); } set { if (dwMaster == null) return; dwMaster["VHALIEFSCH"] = value; OnPropertyChanged("VHALIEFSCH", value); } } //lENGth 0
                public string VHAFILLER2 { get { if (dwMaster == null) return ""; return dwMaster["VHAFILLER2"].ToString(); } set { if (dwMaster == null) return; dwMaster["VHAFILLER2"] = value; OnPropertyChanged("VHAFILLER2", value); } } //lENGth 54
       */
       #endregion
    } 
}
